Full source code website bán hàng thương mại điện tử gần giống shopee
468.903 lượt xem;
1 <?
2 if (isset($_REQUEST['act']))
3 {
4 ?><br>
5 <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#C9C9C9" width="100%" id="AutoNumber1">
6 <tr>
7 <td align=center nowrap class="title"><input type="checkbox" name="chkall" onclick="chkallClick(this);"></td>
8 <td colspan="2" nowrap class="title"> </td>
9 <td align="center" nowrap class="title"><b>ID</b></td>
10 <td align="center" nowrap class="title"><b>Tên </b></td>
11 <td align="center" nowrap class="title"><b>Người đăng</b></td>
12 <td align="center" nowrap class="title"><b>Danh mục hệ thống</b></td>
13 <td align="center" nowrap class="title"><b>Nơi đăng</b></td>
14 <td align="center" nowrap class="title"><b>Ngày đăng</b></td>
15 </tr>
16 <?
17 if ($_REQUEST['cat_id']!='') $cat=killInjection($_REQUEST['cat_id']);
18 $catallsub=GetCatAdv($cat);
19 $where="1=1";
20 $keywords=killInjection($_REQUEST['keywords']);
21 if ($keywords!='')
22 {
23 $where.=" and (name like '%".$keywords."%' or content like '%".$keywords."%'";
24 $where.=") ";
25 }
26 if ($_REQUEST['cat_id']!='') $where.=" and adv_cat in (".$catallsub."0)";
27 if ($_REQUEST['manufacturers_id']!='') $where.=" and providers_id=".$_REQUEST['manufacturers_id'];
28 if ($_REQUEST['pfrom']!='') $where.=" and price>=".$_REQUEST['pfrom'];
29 if ($_REQUEST['pto']!='') $where.=" and price_special<=".$_REQUEST['pto'];
30 if ($_REQUEST['dfrom']!='') $where.=" and products_date_added>=".$_REQUEST['dfrom'];
31 if ($_REQUEST['dto']!='') $where.=" and products_date_added<=".$_REQUEST['dto'];
32
33 $MAXPAGE=20;
34 $p=0;
35 if ($_REQUEST['p']!='') $p=$_REQUEST['p'];
36
37 $result = mysql_query("select count(*) from avd where $where ",$con);
38 $total=mysql_fetch_row($result);
39
40 $sql="select * from avd where $where limit ".$p*$MAXPAGE.",".$MAXPAGE;
41 $result = mysql_query($sql,$con);
42 $i=0;
43 while (($row=mysql_fetch_assoc($result)))
44 {
45 $catinfo=GetCatAdvInfo($row['adv_cat']);
46 $cityinfo=GetCityInfo($row['city']);
47 $i++;
48 if ($i%2) $color="#d5d5d5"; else $color="#e5e5e5";
49 ?>
50 <tr>
51 <td align="center" bgcolor="<? echo $color; ?>" class="smallfont">
52 <input type="checkbox" name="chk[]" value="<? echo $row['id']; ?>"></td>
53 <td align="center" bgcolor="<? echo $color; ?>" class="smallfont">
54 <a href="./?act=adv_m&cat=<? echo $_REQUEST['cat']; ?>&status=<? echo $_REQUEST['status']; ?>&id=<? echo $row['id']; ?>&page=<? echo $page?>">Sửa</a></td>
55 <td align="center" bgcolor="<? echo $color; ?>" class="smallfont">
56 <a onclick="return confirm('Bạn có chắc chắn muốn xoá ?');" href="./?act=adv&action=del&cat=<? echo $_REQUEST['cat']; ?>&status=<? echo $_REQUEST['status']; ?>&id=<? echo $row['id']; ?>">Xoá</a></td>
57 <td bgcolor="<? echo $color; ?>" align="left" align="left" class="smallfont"><? echo $row['id']; ?> </td>
58 <td bgcolor="<? echo $color; ?>" class="smallfont">
59 <a href="../?home=adv&act=views&id=<? echo $row['id']; ?>&cat=<? echo $row['adv_cat']; ?>" target="_blank"><? echo $row['name']; ?></a>
60 </td>
61 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['user']; ?> </td>
62 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $catinfo['name']; ?> </td>
63 <td bgcolor="<? echo $color; ?>" class="smallfont"><?if($row['city']=='0'){?>TOÀN QUỐC<?}else{?><? echo $cityinfo['name']; ?><?}?> </td>
64 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['date']; ?> </td>
65
66 </tr>
67 <?}
68 settype($total[0],int);
69 ?>
70 </table>
71 <?
72 $s="act=search&act=search&keywords=$keywords&search_in_description=".$_REQUEST['search_in_description']."&categories_id=".$_REQUEST['categories_id']."&manufacturers_id=".$_REQUEST['manufacturers_id']."&pfrom=".$_REQUEST['pfrom']."&pto=".$_REQUEST['pto']."&dfrom=".$_REQUEST['dfrom']."&dto=".$REQUEST['dto'];
73 ?>
74
75 <form id="search1" name="search1" style="word-spacing: 0; margin: 0" method="GET" action="index.php?<? echo $s; ?>">
76 <input type="hidden" name="menu" value="<? echo $_REQUEST['menu']; ?>">
77 <input type="hidden" name="act" value="<? echo $_REQUEST['act']; ?>">
78 <input type="hidden" name="keywords" value="<? echo $_REQUEST['keywords']; ?>">
79 <input type="hidden" name="search_in_description" value="<? echo $_REQUEST['search_in_description']; ?>">
80 <input type="hidden" name="categories_id" value="<? echo $_REQUEST['categories_id']; ?>">
81 <input type="hidden" name="manufacturers_id" value="<? echo $_REQUEST['manufacturers_id']; ?>">
82 <input type="hidden" name="pfrom" value="<? echo $_REQUEST['pfrom']; ?>">
83 <input type="hidden" name="pto" value="<? echo $_REQUEST['pto']; ?>">
84 <input type="hidden" name="dfrom" value="<? echo $_REQUEST['dfrom']; ?>">
85 <input type="hidden" name="dto" value="<? echo $_REQUEST['dto']; ?>">
86 <input type="hidden" id="trang" name="p" value="1">
87 <TABLE cellSpacing=10 cellPadding=0 width="100%" border=0 id="table35" style="line-height: 120%; text-align: justify">
88 <?
89 $pages=count_page($total[0],$MAXPAGE);
90 echo '<tr><td colspan="2" align="center"><hr class="fieldkey" width="100%" SIZE=1></td></tr>';
91 echo '<tr><td class="smallfont" align="left">Trình bày <b>'.($p+1).'</b> đến <b>'.(int)($total[0]/$MAXPAGE+1).'</b> (trong <b>'.$total[0].'</b> sản phẩm)</td>';
92 echo '<td class="smallfont" align="right">Kết quả: ';
93 //$param="act=search&keywords=$keywords&search_in_description=".$_REQUEST['search_in_description']."&categories_id=".$_REQUEST['categories_id']."&manufacturers_id=".$_REQUEST['manufacturers_id']."&pfrom=".$_REQUEST['pfrom']."&pto=".$_REQUEST['pto']."&dfrom=".$_REQUEST['dfrom']."&dto=".$REQUEST['dto'];
94 if ($p>1) echo '<a title="Đầu tiên" href="#" onclick="javascript:changepage(0);return false;">[<]</a> ';
95 if ($p>0) echo '<a title="Về trước" href="#" onclick="javascript:changepage('.($p-1).');return false;">[<<]</a> ';
96 $from=($p-10>0?$p-10:0);
97 $to=($p+10<$pages?$p+10:$pages);
98 for ($i=$from;$i<$to;$i++)
99 {
100 //if ($i!=$p) echo '<a href="./?menu=search&'.$param.'&p='.$i.'">'.($i+1).' </a>';
101 if ($i!=$p) echo '<a href="#" onclick="javascript:changepage('.$i.');return false;">'.($i+1).' </a>';
102 else echo '<b>'.($i+1).'</b> ';
103 }
104 if ($p<$i-1) echo '<a title="Tiếp theo" href="#" onclick="javascript:changepage('.($p+1).');return false;">[>>]</a> ';
105 if ($p<$pages-1) echo '<a title="Cuối cùng" href="#" onclick="javascript:changepage('.($pages-1).');return false;">[>]</a> ';
106 echo '</td></tr></table>';
107 ?>
108 </form>
109
110 <script>
111 function changepage(num)
112 {
113 document.all.trang.value=num;
114 search1.submit();
115 }
116 </script>
117
118 <?
119 }
120 else
121 {
122 ?>
123 <TABLE border="0" cellpadding="10" cellspacing="1" width="100%" id="table1">
124 <TR><TD class="DialogBox">
125 <FORM name="searchform" action="./" method="GET">
126 <table cellSpacing="0" cellPadding="2" width="100%" border="0" id="table2">
127 <tr>
128 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Từ khóa:</span></font></td>
129 <td class="fieldValue" width="55%">
130 <span style="font-size: 8.5pt"><font size="1" face="Tahoma">
131 <input name="keywords" size="255" style="width: 200; height:22"></font></span></td>
132 </tr>
133 <tr>
134 <td width="35%" align="right"> </td>
135 <td class="fieldValue" width="55%">
136 <span style="font-size: 8.5pt"><font face="Tahoma">
137 <input type="checkbox" value="1" name="search_in_description"> Chỉ tìm
138 trong phần mô tả sản phẩm</font></span></td>
139 </tr>
140 <tr>
141 <td width="35%" align="right"> </td>
142 <td class="fieldValue" width="55%">
143 <font face="Verdana" size="1">
144 <span style="font-size: 8.5pt">
145 <font face="Tahoma">
146 <input type=submit value="Tìm kiếm" class=buttonorange onmouseover="this.className='buttonblue'" onmouseout="this.className='buttonorange'"></font></span></font></td>
147 </tr>
148 <tr>
149 <td width="35%" align="right"> </td>
150 <td class="fieldValue" width="55%"> </td>
151 </tr>
152 <tr>
153 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Trong danh mục:</span></font></td>
154 <td class="fieldValue" width="55%">
155 <span style="font-size: 8.5pt"><font face="Tahoma">
156 <select name="categories_id" size="1" style="width: 200">
157 <option selected value="">[Toàn bộ danh mục]</option>
158 <?
159 $cats=GetListCategory(17);
160 foreach ($cats as $cat)
161 {
162 echo '<option value="'.$cat[0].'">'.$cat[1].'</option>';
163 }
164 ?>
165 </select></font></span></td>
166 </tr>
167 <tr>
168 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Giá (>=):</span></font></td>
169 <td class="fieldValue" width="55%"><span style="font-size: 8.5pt">
170 <font face="Tahoma"><input name="pfrom"></font></span></td>
171 </tr>
172 <tr>
173 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Giá (<=):</span></font></td>
174 <td class="fieldValue" width="55%"><span style="font-size: 8.5pt">
175 <font face="Tahoma"><input name="pto"></font></span></td>
176 </tr>
177 <tr>
178 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Ngày (>=):</span></font></td>
179 <td class="fieldValue" width="55%">
180 <span style="font-size: 8.5pt"><font face="Tahoma">
181 <input name="dfrom"> (tháng/ngày/năm)</font></span></td>
182 </tr>
183 <tr>
184 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Ngày (<=):</span></font></td>
185 <td class="fieldValue" width="55%">
186 <span style="font-size: 8.5pt"><font face="Tahoma">
187 <input name="dto"> (tháng/ngày/năm)</font></span></td>
188 </tr>
189 </table>
190
191 <input type="hidden" name="act" value="search">
192
193 <input type="hidden" name="menu" value="search">
194
195 </FORM>
196 </TD></TR>
197 </TABLE>
198 <?
199 }
200 ?>
2 if (isset($_REQUEST['act']))
3 {
4 ?><br>
5 <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#C9C9C9" width="100%" id="AutoNumber1">
6 <tr>
7 <td align=center nowrap class="title"><input type="checkbox" name="chkall" onclick="chkallClick(this);"></td>
8 <td colspan="2" nowrap class="title"> </td>
9 <td align="center" nowrap class="title"><b>ID</b></td>
10 <td align="center" nowrap class="title"><b>Tên </b></td>
11 <td align="center" nowrap class="title"><b>Người đăng</b></td>
12 <td align="center" nowrap class="title"><b>Danh mục hệ thống</b></td>
13 <td align="center" nowrap class="title"><b>Nơi đăng</b></td>
14 <td align="center" nowrap class="title"><b>Ngày đăng</b></td>
15 </tr>
16 <?
17 if ($_REQUEST['cat_id']!='') $cat=killInjection($_REQUEST['cat_id']);
18 $catallsub=GetCatAdv($cat);
19 $where="1=1";
20 $keywords=killInjection($_REQUEST['keywords']);
21 if ($keywords!='')
22 {
23 $where.=" and (name like '%".$keywords."%' or content like '%".$keywords."%'";
24 $where.=") ";
25 }
26 if ($_REQUEST['cat_id']!='') $where.=" and adv_cat in (".$catallsub."0)";
27 if ($_REQUEST['manufacturers_id']!='') $where.=" and providers_id=".$_REQUEST['manufacturers_id'];
28 if ($_REQUEST['pfrom']!='') $where.=" and price>=".$_REQUEST['pfrom'];
29 if ($_REQUEST['pto']!='') $where.=" and price_special<=".$_REQUEST['pto'];
30 if ($_REQUEST['dfrom']!='') $where.=" and products_date_added>=".$_REQUEST['dfrom'];
31 if ($_REQUEST['dto']!='') $where.=" and products_date_added<=".$_REQUEST['dto'];
32
33 $MAXPAGE=20;
34 $p=0;
35 if ($_REQUEST['p']!='') $p=$_REQUEST['p'];
36
37 $result = mysql_query("select count(*) from avd where $where ",$con);
38 $total=mysql_fetch_row($result);
39
40 $sql="select * from avd where $where limit ".$p*$MAXPAGE.",".$MAXPAGE;
41 $result = mysql_query($sql,$con);
42 $i=0;
43 while (($row=mysql_fetch_assoc($result)))
44 {
45 $catinfo=GetCatAdvInfo($row['adv_cat']);
46 $cityinfo=GetCityInfo($row['city']);
47 $i++;
48 if ($i%2) $color="#d5d5d5"; else $color="#e5e5e5";
49 ?>
50 <tr>
51 <td align="center" bgcolor="<? echo $color; ?>" class="smallfont">
52 <input type="checkbox" name="chk[]" value="<? echo $row['id']; ?>"></td>
53 <td align="center" bgcolor="<? echo $color; ?>" class="smallfont">
54 <a href="./?act=adv_m&cat=<? echo $_REQUEST['cat']; ?>&status=<? echo $_REQUEST['status']; ?>&id=<? echo $row['id']; ?>&page=<? echo $page?>">Sửa</a></td>
55 <td align="center" bgcolor="<? echo $color; ?>" class="smallfont">
56 <a onclick="return confirm('Bạn có chắc chắn muốn xoá ?');" href="./?act=adv&action=del&cat=<? echo $_REQUEST['cat']; ?>&status=<? echo $_REQUEST['status']; ?>&id=<? echo $row['id']; ?>">Xoá</a></td>
57 <td bgcolor="<? echo $color; ?>" align="left" align="left" class="smallfont"><? echo $row['id']; ?> </td>
58 <td bgcolor="<? echo $color; ?>" class="smallfont">
59 <a href="../?home=adv&act=views&id=<? echo $row['id']; ?>&cat=<? echo $row['adv_cat']; ?>" target="_blank"><? echo $row['name']; ?></a>
60 </td>
61 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['user']; ?> </td>
62 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $catinfo['name']; ?> </td>
63 <td bgcolor="<? echo $color; ?>" class="smallfont"><?if($row['city']=='0'){?>TOÀN QUỐC<?}else{?><? echo $cityinfo['name']; ?><?}?> </td>
64 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['date']; ?> </td>
65
66 </tr>
67 <?}
68 settype($total[0],int);
69 ?>
70 </table>
71 <?
72 $s="act=search&act=search&keywords=$keywords&search_in_description=".$_REQUEST['search_in_description']."&categories_id=".$_REQUEST['categories_id']."&manufacturers_id=".$_REQUEST['manufacturers_id']."&pfrom=".$_REQUEST['pfrom']."&pto=".$_REQUEST['pto']."&dfrom=".$_REQUEST['dfrom']."&dto=".$REQUEST['dto'];
73 ?>
74
75 <form id="search1" name="search1" style="word-spacing: 0; margin: 0" method="GET" action="index.php?<? echo $s; ?>">
76 <input type="hidden" name="menu" value="<? echo $_REQUEST['menu']; ?>">
77 <input type="hidden" name="act" value="<? echo $_REQUEST['act']; ?>">
78 <input type="hidden" name="keywords" value="<? echo $_REQUEST['keywords']; ?>">
79 <input type="hidden" name="search_in_description" value="<? echo $_REQUEST['search_in_description']; ?>">
80 <input type="hidden" name="categories_id" value="<? echo $_REQUEST['categories_id']; ?>">
81 <input type="hidden" name="manufacturers_id" value="<? echo $_REQUEST['manufacturers_id']; ?>">
82 <input type="hidden" name="pfrom" value="<? echo $_REQUEST['pfrom']; ?>">
83 <input type="hidden" name="pto" value="<? echo $_REQUEST['pto']; ?>">
84 <input type="hidden" name="dfrom" value="<? echo $_REQUEST['dfrom']; ?>">
85 <input type="hidden" name="dto" value="<? echo $_REQUEST['dto']; ?>">
86 <input type="hidden" id="trang" name="p" value="1">
87 <TABLE cellSpacing=10 cellPadding=0 width="100%" border=0 id="table35" style="line-height: 120%; text-align: justify">
88 <?
89 $pages=count_page($total[0],$MAXPAGE);
90 echo '<tr><td colspan="2" align="center"><hr class="fieldkey" width="100%" SIZE=1></td></tr>';
91 echo '<tr><td class="smallfont" align="left">Trình bày <b>'.($p+1).'</b> đến <b>'.(int)($total[0]/$MAXPAGE+1).'</b> (trong <b>'.$total[0].'</b> sản phẩm)</td>';
92 echo '<td class="smallfont" align="right">Kết quả: ';
93 //$param="act=search&keywords=$keywords&search_in_description=".$_REQUEST['search_in_description']."&categories_id=".$_REQUEST['categories_id']."&manufacturers_id=".$_REQUEST['manufacturers_id']."&pfrom=".$_REQUEST['pfrom']."&pto=".$_REQUEST['pto']."&dfrom=".$_REQUEST['dfrom']."&dto=".$REQUEST['dto'];
94 if ($p>1) echo '<a title="Đầu tiên" href="#" onclick="javascript:changepage(0);return false;">[<]</a> ';
95 if ($p>0) echo '<a title="Về trước" href="#" onclick="javascript:changepage('.($p-1).');return false;">[<<]</a> ';
96 $from=($p-10>0?$p-10:0);
97 $to=($p+10<$pages?$p+10:$pages);
98 for ($i=$from;$i<$to;$i++)
99 {
100 //if ($i!=$p) echo '<a href="./?menu=search&'.$param.'&p='.$i.'">'.($i+1).' </a>';
101 if ($i!=$p) echo '<a href="#" onclick="javascript:changepage('.$i.');return false;">'.($i+1).' </a>';
102 else echo '<b>'.($i+1).'</b> ';
103 }
104 if ($p<$i-1) echo '<a title="Tiếp theo" href="#" onclick="javascript:changepage('.($p+1).');return false;">[>>]</a> ';
105 if ($p<$pages-1) echo '<a title="Cuối cùng" href="#" onclick="javascript:changepage('.($pages-1).');return false;">[>]</a> ';
106 echo '</td></tr></table>';
107 ?>
108 </form>
109
110 <script>
111 function changepage(num)
112 {
113 document.all.trang.value=num;
114 search1.submit();
115 }
116 </script>
117
118 <?
119 }
120 else
121 {
122 ?>
123 <TABLE border="0" cellpadding="10" cellspacing="1" width="100%" id="table1">
124 <TR><TD class="DialogBox">
125 <FORM name="searchform" action="./" method="GET">
126 <table cellSpacing="0" cellPadding="2" width="100%" border="0" id="table2">
127 <tr>
128 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Từ khóa:</span></font></td>
129 <td class="fieldValue" width="55%">
130 <span style="font-size: 8.5pt"><font size="1" face="Tahoma">
131 <input name="keywords" size="255" style="width: 200; height:22"></font></span></td>
132 </tr>
133 <tr>
134 <td width="35%" align="right"> </td>
135 <td class="fieldValue" width="55%">
136 <span style="font-size: 8.5pt"><font face="Tahoma">
137 <input type="checkbox" value="1" name="search_in_description"> Chỉ tìm
138 trong phần mô tả sản phẩm</font></span></td>
139 </tr>
140 <tr>
141 <td width="35%" align="right"> </td>
142 <td class="fieldValue" width="55%">
143 <font face="Verdana" size="1">
144 <span style="font-size: 8.5pt">
145 <font face="Tahoma">
146 <input type=submit value="Tìm kiếm" class=buttonorange onmouseover="this.className='buttonblue'" onmouseout="this.className='buttonorange'"></font></span></font></td>
147 </tr>
148 <tr>
149 <td width="35%" align="right"> </td>
150 <td class="fieldValue" width="55%"> </td>
151 </tr>
152 <tr>
153 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Trong danh mục:</span></font></td>
154 <td class="fieldValue" width="55%">
155 <span style="font-size: 8.5pt"><font face="Tahoma">
156 <select name="categories_id" size="1" style="width: 200">
157 <option selected value="">[Toàn bộ danh mục]</option>
158 <?
159 $cats=GetListCategory(17);
160 foreach ($cats as $cat)
161 {
162 echo '<option value="'.$cat[0].'">'.$cat[1].'</option>';
163 }
164 ?>
165 </select></font></span></td>
166 </tr>
167 <tr>
168 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Giá (>=):</span></font></td>
169 <td class="fieldValue" width="55%"><span style="font-size: 8.5pt">
170 <font face="Tahoma"><input name="pfrom"></font></span></td>
171 </tr>
172 <tr>
173 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Giá (<=):</span></font></td>
174 <td class="fieldValue" width="55%"><span style="font-size: 8.5pt">
175 <font face="Tahoma"><input name="pto"></font></span></td>
176 </tr>
177 <tr>
178 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Ngày (>=):</span></font></td>
179 <td class="fieldValue" width="55%">
180 <span style="font-size: 8.5pt"><font face="Tahoma">
181 <input name="dfrom"> (tháng/ngày/năm)</font></span></td>
182 </tr>
183 <tr>
184 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Ngày (<=):</span></font></td>
185 <td class="fieldValue" width="55%">
186 <span style="font-size: 8.5pt"><font face="Tahoma">
187 <input name="dto"> (tháng/ngày/năm)</font></span></td>
188 </tr>
189 </table>
190
191 <input type="hidden" name="act" value="search">
192
193 <input type="hidden" name="menu" value="search">
194
195 </FORM>
196 </TD></TR>
197 </TABLE>
198 <?
199 }
200 ?>